update igw_system_menu_info t set t.valid_flag='1' where t.permission_flags ='windControl' and t.system_id=(select pk_id from igw_system_info where VALID_FLAG = '0' and system_code = 'ItApp-ProductInfo-Management');

insert into igw_system_menu_info
  (pk_id,
   parent_id,
   system_id,
   menu_level,
   menu_name,
   menu_rout,
   permission_flags,
   VALID_FLAG,
   CREATED_USER,
   CREATED_DATE)
VALUES
  (igw_system_menu_info_PK.NEXTVAL,
   '0',
   (select pk_id from igw_system_info where  VALID_FLAG = '0' and system_code = 'ItApp-ProductInfo-Management'),
   '1',
   '信息审核',
   '/InformationAudit',
   'InformationAudit',
   '0',
   'system',
   sysdate); 


insert into igw_system_menu_info
  (pk_id,
   parent_id,
   system_id,
   menu_level,
   menu_name,
   menu_rout,
   permission_flags,
   VALID_FLAG,
   CREATED_USER,
   CREATED_DATE)
VALUES
  (igw_system_menu_info_PK.NEXTVAL,
  (select pk_id from igw_system_menu_info where VALID_FLAG = '0' and permission_flags = 'InformationAudit' and system_id = (select pk_id from igw_system_info where  VALID_FLAG = '0' and system_code = 'ItApp-ProductInfo-Management') ),
  (select pk_id from igw_system_info where  VALID_FLAG = '0' and system_code = 'ItApp-ProductInfo-Management'),
   '1',
   '风控信息审核',
   '/windControl',
   'windControl',
   '0',
   'system',
   sysdate); 

  



 